Import File Example

An import file can be an activity file, resource assignment file, or a combination of both.

This is an example of an activity file.

1.1.1,1600,01,161,This is act 1,12/15/09,02/03/02
1.1.1,1600,02,162,This is act 2,02/09/02,03/30/0

This is an example of a resource assignment file.

161,ENG1,156,12/15/09,12/31/09
161,ENG1,200,01/01/02,01/31/02
161,ENG1,10,02/01/02,02/03/02
161,ENG2,35,12/15/09,12/31/09
161,ENG2,40,01/01/02,01/15/02
162,TECH,206,02/01/02,02/28/02
162,TECH,290,03/01/02,03/30/02
162,MATL,10000,02/01/02,02/01/02

This is an example of a combined activity and resource assignment file.

1.1.1.1,1400,01,1.1.1.1.01,06/01/2007,07/12/2007,LABOR,100,10000
1.1.1.1,1400,02,1.1.1.1.02,06/01/2007,10/13/2007,MAT,0,100000
1.1.1.2,1420,01,1.1.1.2.01,09/01/2007,12/23/2007,LABOR,50,5000

If you are loading a forecast, you are loading forecast dates and forecasted resource requirements. Therefore, the resource requirements should not be before the status date.

For example, if the project status date was 12/31/09, the resource assignment file will be as follows:

161,ENG1,200,01/01/02,01/31/02
161,ENG1,10,02/01/02,02/03/02
161,ENG2,40,01/01/02,01/15/02
162,TECH,206,02/01/02,02/28/02
162,TECH,290,03/01/02,03/30/02
162,MATL,10000,02/01/02,02/01/02
Note: To easily create an import file for the ancillary data you want to import into Cobra, you can generate the corresponding export report to see a sample CSV file for import. If you save the data as a CSV, XLS, or XLSX file, you can select the File contains a header row option on the Ancillary File Field Mapper page and just import the file.